In general, accommodations in Vancouver are on the expensive side. Most upscale hotel rooms begin at $200-250/night, although you can find reasonably priced ones in the $100-180 range quite often. Most motel rooms cost somewhere between $80-150/night. If you are lucky to find hostel accommodation, the cheapest of these will cost around $20/night, more reasonably between $35-50.
The City Centre is centrally located for attractions and has the bulk of Vancouver's accommodation, including most of the high-end hotels and backpackers hostels. If you don't mind getting away from the chain hotels, there are a number of smaller boutique hotels outside of the central business district but still close to the action that are cheaper than the four and five star options downtown. Backpacker hostels are another cheap option with beds starting at $25 if you don't mind sharing a room.
Staying outside the City Centre area may give you a wider choice of affordable accommodations. There are a few budget hotels/motels along Kingsway in East Van and Broadway in South Granville. A number of B&B's are also scattered throughout the city in each district. If you want/need to stay close to the airport, Richmond has a number of hotels with varying degrees of luxury and price.
Finally, if you don't mind driving or commuting in to see Vancouver, the suburbs also have some cheaper options. North Vancouver, Burnaby and New Westminster all have easy access to Vancouver via the public transit system. The closest Provincial Parks with campgrounds are near Maple Ridge Golden Ears Provincial Park, Chilliwack, and Squamish.